
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_SinhVien_UpdateSinhVienByMaSV]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_SinhVien_UpdateSinhVienByMaSV]
GO
create procedure sp_SinhVien_UpdateSinhVienByMaSV
	@MaSV varchar(10),
	@Ten_SV nvarchar(100),	
	@Ngay_Sinh varchar(40),
	@Gioi_Tinh varchar(40),
	@Dia_chi nvarchar(100)
as
begin			
	UPDATE SinhVien 
	SET Ten_SV=@Ten_SV,
		Ngay_Sinh=@Ngay_Sinh,
		Gioi_Tinh=@Gioi_Tinh,
		Dia_Chi=@Dia_chi		
	WHERE
		MaSV=@MaSV
end



